Retail Agent Cost Account Reconciliation

You are here: Reports > Retail Agent Reports > Retail Agent Cost Account Reconciliation

Retail Agent Cost Account Reconciliation Report

This report will gather debit and credit line items from transactions that have posted to the retail agent cost accounts. Report line item data originates from retail agent invoices. The transaction types that cause the retail agent cost to be recognized in the retail agent cost accounts are limited to Invoices, Reconciliations, Cash Receipts, and Disbursements when using normal retail agent workflows.

To Generate a Retail Agent Cost Account Reconciliation Report

On the Primary menu, click REPORTS.
On the REPORTS menu, click Reports. The Nexsure Reports dialog box is displayed.

In the Report Type list, select Accounting.
In the Report Category list, select Reconciliation.
In the Available Reports list, select Retail Agent Cost Account Reconciliation.
Click OK. The summary tab is displayed.

On the navigation toolbar, click New Report Criteria to go to the Nexsure Reports > Report Criteria dialog box.

Under Organization Information, click [Select]. The Nexsure Organization Criteria dialog box is displayed.

In the Nexsure Organization Criteria dialog box, select the desired organization information (in the Region, Territory, Branch, Department, and Unit lists) to query for the report and click Add.

Note: If the report is being run for the entire organization it is not necessary to make a selection in the Nexsure Organization Criteria dialog box. Multiple entities may be selected for each report. First select the regions to determine the available territories. All territories for all selected regions will be displayed for selection.

Once information has been added to the Include list, it can be removed by selecting the item and clicking Del to remove individual items or Clear to remove all items.

If the organization information is correct, click OK. The organization information selected is added to the Nexsure Reports > Report Criteria screen.
In the Date Information area, select date filters. Date filters are used to set the beginning and ending date of the report.

The available options are:

Date Type: Select either As Of Date or Date Range.
As Of: Set the end date of the report by using either the calendar dialog box or entering a date in the box.
Period: Periods can be selected from the Period list, which are based on agency accounting periods.
Year: Fiscal years based on the general ledger periods and default to current year.

Note: The Period and Year selections are available to pre-fill the Date From and Date To boxes. The report will use only the Date From and Date To date range when compiling data, regardless of what is selected in the Period and Year lists.

Date From: Start date for a selected period.
Date To: End date for the selected period.

Note: The date parameters set in the report criteria refer to the date the retail agent cost is recognized, not the date the invoice is booked. Although in Accrual accounting these occur on the same date, in Cash accounting they are commonly not the same date.

In the General Ledger Information area, select the GL account.

In the Assignment Information area, select a Retail Agent by clicking the Ellipsis button and selecting one or more retail agents. The default for this selection is blank which will return results for all retail agents.

In the Grouping / Sorting Options area, select the grouping and sorting options that affect the layout of the report.

The available options are:

Group Field [1]: Apply a primary grouping by:

Group Field [2]: Apply a secondary grouping by:

Sort Field [1]: Sort transactions in ascending or descending order within groups. Available selections are:

Sort Order: Select either Ascending or Descending to sort transactions within the group field selected. Ascending will set the order from A-Z. Descending will set the order from Z-A.

In the Report Format Options area, select one of the options in the Format Type list.

The available formats are:

PDF: This is the default setting that creates the report in a PDF format. The report data is static and cannot be manipulated.
XLS (unformatted): Microsoft Excel document that can be manipulated as an .xls file. The report is generated with no formatting so cells are not merged and data is stored in individual cells. Column headers appear but page breaks are not inserted.

In the Nexsure Reports > Report Criteria dialog box, click OK. The Retail Agent Cost Account report will start compiling.

To update the compiling status, click Refresh on the navigation toolbar.

Once the report Status is Complete, click the View icon to view the report.